-: Something outstanding to me within PowerPoint
is the ability to put two different charts
on physically one chart.
This is called a combo chart.
Let me take the data.
We have laptop stands, revenue from selling, and units sold.
This isn't really a metric that should be put together
but we will manage to do so using a combo chart.
The first task is add a clustered column chart.
I'll open chart, column, clustered column.
Okay.
I will insert the data.
Of course, I need to reduce the selected data.
And what do we have now?
We have the revenue, pretty high
because we have this metric on the left side,
and the unit sold, very low because we have this
in a lower number.
What can we do to change this?
Number two.
Task number two is right click,
change chart type
and select a combo chart.
Right click, change chart type
selecting a combo chart, and here within the combo chart,
combo means multiple on one.
The revenue is displayed as a clustered column
but the unit sold should be displayed as a line.
Perfect. Now this will look a little different.
You can see the preview here, but still not there.
There is a special function called secondary axis.
If you enable the secondary axis, you press okay.
The column chart has its own axis
and the line chart has its own axis here
on the right side as well.
This is beautiful.
Number three is to right-click on the new line chart
and form a data series.
You can also select the secondary axis
by right-clicking on the series directly,
formatting data series,
and here in its native options
you can select the primary axis or secondary axis
if you want this to be put on the secondary axis.
Now, you wanna add data labels for both.
Okay. I'll simply select the chart
hit the plus sign and select data labels.
As you can see, at this point,
the data labels are barely visible.
We'll correct that in a moment
when we go to editing.
Number five, adjust access values so they don't overlap.
I don't like that the line chart is so high up here.
I would like to lower the line chart
to make everything more visible.
I can do so by changing the values on the axis
and this applies to any chart you work with with PowerPoint.
I'll click on the axis directly.
I'll increase the minimum maybe to 20
so it got a little lower,
but the maximum should be much much increased to like 300.
This way we put this line a little lower.
Now. Beautiful.
I can make the data labels extremely visible.
Like number six is
make the unit sales data labels extremely visible.
So those are the data labels for our units sold.
You can see or you cannot see them.
What you can do, you can click on them.
You can simply go to the filling options.
You can give them a solid fill.
This is instantly better because we have a white color.
If you want, you can of course
use one of the colors that we used previously.
Then you can go on the right side to the text options
and give it white font.
I will maybe increase the font.
I press control B.
Now, everything would be much, much clearer
and more visible.
This is how you can edit a chart, not only a combo chart
but how you can edit data labels, edit axis on charts
and make sure that if you use a combo chart
that sometimes it's useful to select it to be displayed
on a secondary axis.
Now you can open PowerPoint and try that for yourself.